Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	331262
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	88200
Duplicate rows (%)	26.6%
Total size in memory	101.1 MiB
Average record size in memory	320.0 B

Variable types

Numeric	14
Categorical	4
Unsupported	3

Warnings

`RevisionNumber` has constant value "1"	Constant
`OrderQuantity` has constant value "1"	Constant
Dataset has 88200 (26.6%) duplicate rows	Duplicates
`SalesOrderNumber` has a high cardinality: 27659 distinct values	High cardinality
`SaleTypeKey` is highly correlated with `SalesOrderLineNumber`	High correlation
`SalesOrderLineNumber` is highly correlated with `SaleTypeKey`	High correlation
`UnitPrice` is highly correlated with `ProductStandardCost` and 5 other fields	High correlation
`ProductStandardCost` is highly correlated with `UnitPrice` and 5 other fields	High correlation
`TotalProductCost` is highly correlated with `UnitPrice` and 5 other fields	High correlation
`SalesAmount` is highly correlated with `UnitPrice` and 5 other fields	High correlation
`TaxAmt` is highly correlated with `UnitPrice` and 5 other fields	High correlation
`Freight` is highly correlated with `UnitPrice` and 5 other fields	High correlation
`ExtendedAmount` is highly correlated with `UnitPrice` and 5 other fields	High correlation
`RevisionNumber` is highly correlated with `OrderQuantity` and 1 other fields	High correlation
`OrderQuantity` is highly correlated with `RevisionNumber` and 1 other fields	High correlation
`PromotionKey` is highly correlated with `RevisionNumber` and 1 other fields	High correlation
`OrderDate` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`DueDate` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ShipDate` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`UnitPriceDiscountPct` has 290427 (87.7%) zeros	Zeros

Reproduction

Analysis started	2021-03-08 02:59:28.280623
Analysis finished	2021-03-08 03:00:31.756630
Duration	1 minute and 3.48 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

DateKey
Real number (ℝ_≥0)

Distinct	1123
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20159803.01
Minimum	20131229
Maximum	20170128
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	20131229
5-th percentile	20150505
Q1	20160404
median	20160714
Q3	20161018
95-th percentile	20161224
Maximum	20170128
Range	38899
Interquartile range (IQR)	614

Descriptive statistics

Standard deviation	4624.07144
Coefficient of variation (CV)	0.0002293708643
Kurtosis	8.718159645
Mean	20159803.01
Median Absolute Deviation (MAD)	307
Skewness	-2.460296333
Sum	6.678176664 × 10¹²
Variance	21382036.68
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20161212	1421	0.4%
20161001	1358	0.4%
20160605	1322	0.4%
20160819	1311	0.4%
20161209	1308	0.4%
20161205	1242	0.4%
20161017	1216	0.4%
20161226	1213	0.4%
20161219	1212	0.4%
20161215	1211	0.4%
Other values (1113)	318448	96.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
20131229	25	< 0.1%
20131230	20	< 0.1%
20131231	25	< 0.1%
20140101	10	< 0.1%
20140102	25	< 0.1%
20140103	20	< 0.1%
20140104	15	< 0.1%
20140105	15	< 0.1%
20140106	30	< 0.1%
20140107	15	< 0.1%

Value	Count	Frequency (%)
20170128	527	0.2%
20170127	342	0.1%
20170126	387	0.1%
20170125	452	0.1%
20170124	355	0.1%
20170123	415	0.1%
20170122	307	0.1%
20170121	468	0.1%
20170120	389	0.1%
20170119	413	0.1%

ProductKey
Real number (ℝ_≥0)

Distinct	606
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	325.3774233
Minimum	1
Maximum	606
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	57
Q1	216
median	324
Q3	417
95-th percentile	572
Maximum	606
Range	605
Interquartile range (IQR)	201

Descriptive statistics

Standard deviation	154.0875158
Coefficient of variation (CV)	0.4735654803
Kurtosis	-0.6406707325
Mean	325.3774233
Median Absolute Deviation (MAD)	96
Skewness	-0.3000840847
Sum	107785176
Variance	23742.96251
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
303	8488	2.6%
400	8488	2.6%
403	6382	1.9%
306	6382	1.9%
415	6190	1.9%
318	6190	1.9%
319	4752	1.4%
416	4752	1.4%
311	4523	1.4%
557	4244	1.3%
Other values (596)	270871	81.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2230	0.7%
2	2085	0.6%
3	2125	0.6%
4	2190	0.7%
5	429	0.1%
6	442	0.1%
7	452	0.1%
8	413	0.1%
9	336	0.1%
10	281	0.1%

Value	Count	Frequency (%)
606	334	0.1%
605	232	0.1%
604	216	0.1%
603	235	0.1%
602	246	0.1%
601	88	< 0.1%
600	106	< 0.1%
599	97	< 0.1%
598	147	< 0.1%
597	160	< 0.1%

CustomerKey
Real number (ℝ_≥0)

Distinct	18484
Distinct (%)	5.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	18860.50353
Minimum	11000
Maximum	29483
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	11000
5-th percentile	11410.05
Q1	14023
median	18177
Q3	23447
95-th percentile	28100
Maximum	29483
Range	18483
Interquartile range (IQR)	9424

Descriptive statistics

Standard deviation	5428.760474
Coefficient of variation (CV)	0.2878375153
Kurtosis	-1.163990054
Mean	18860.50353
Median Absolute Deviation (MAD)	4601
Skewness	0.276155324
Sum	6247768121
Variance	29471440.28
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11300	383	0.1%
11185	372	0.1%
11277	365	0.1%
11262	356	0.1%
11287	352	0.1%
11091	335	0.1%
11176	335	0.1%
11331	334	0.1%
11276	321	0.1%
11566	318	0.1%
Other values (18474)	327791	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11000	43	< 0.1%
11001	59	< 0.1%
11002	20	< 0.1%
11003	50	< 0.1%
11004	29	< 0.1%
11005	34	< 0.1%
11006	28	< 0.1%
11007	41	< 0.1%
11008	37	< 0.1%
11009	26	< 0.1%

Value	Count	Frequency (%)
29483	5	< 0.1%
29482	5	< 0.1%
29481	5	< 0.1%
29480	26	< 0.1%
29479	5	< 0.1%
29478	18	< 0.1%
29477	14	< 0.1%
29476	5	< 0.1%
29475	5	< 0.1%
29474	5	< 0.1%

PromotionKey
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.3 MiB

1	319138
2	11931
13	115
14	78

Length

Max length	2
Median length	1
Mean length	1.00058262
Min length	1

Characters and Unicode

Total characters	331455
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	319138	96.3%
2	11931	3.6%
13	115	< 0.1%
14	78	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	319138	96.3%
2	11931	3.6%
13	115	< 0.1%
14	78	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	319331	96.3%
2	11931	3.6%
3	115	< 0.1%
4	78	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	331455	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	319331	96.3%
2	11931	3.6%
3	115	< 0.1%
4	78	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	331455	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	319331	96.3%
2	11931	3.6%
3	115	< 0.1%
4	78	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	331455	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	319331	96.3%
2	11931	3.6%
3	115	< 0.1%
4	78	< 0.1%

CurrencyKey
Real number (ℝ_≥0)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	69.66434122
Minimum	6
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	6
5-th percentile	6
Q1	19
median	100
Q3	100
95-th percentile	100
Maximum	100
Range	94
Interquartile range (IQR)	81

Descriptive statistics

Standard deviation	42.20774105
Coefficient of variation (CV)	0.6058729662
Kurtosis	-1.463107111
Mean	69.66434122
Median Absolute Deviation (MAD)	0
Skewness	-0.7107491323
Sum	23077149
Variance	1781.493405
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
100	182918	55.2%
6	71534	21.6%
19	39590	12.0%
98	36545	11.0%
29	380	0.1%
39	295	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	71534	21.6%
19	39590	12.0%
29	380	0.1%
39	295	0.1%
98	36545	11.0%
100	182918	55.2%

Value	Count	Frequency (%)
100	182918	55.2%
98	36545	11.0%
39	295	0.1%
29	380	0.1%
19	39590	12.0%
6	71534	21.6%

OrderDate
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	12.6 MiB

DueDate
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	12.6 MiB

ShipDate
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	12.6 MiB

SaleTypeKey
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.853403047
Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	4
Maximum	8
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9982626371
Coefficient of variation (CV)	0.5386106594
Kurtosis	0.8058291079
Mean	1.853403047
Median Absolute Deviation (MAD)	1
Skewness	1.105900491
Sum	613962
Variance	0.9965282926
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	156023	47.1%
2	98098	29.6%
3	52460	15.8%
4	19846	6.0%
5	4129	1.2%
6	620	0.2%
7	74	< 0.1%
8	12	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	156023	47.1%
2	98098	29.6%
3	52460	15.8%
4	19846	6.0%
5	4129	1.2%
6	620	0.2%
7	74	< 0.1%
8	12	< 0.1%

Value	Count	Frequency (%)
8	12	< 0.1%
7	74	< 0.1%
6	620	0.2%
5	4129	1.2%
4	19846	6.0%
3	52460	15.8%
2	98098	29.6%
1	156023	47.1%

SalesOrderNumber
Categorical

HIGH CARDINALITY

Distinct	27659
Distinct (%)	8.3%
Missing	0
Missing (%)	0.0%
Memory size	20.2 MiB

SO70714	45
SO58845	43
SO72656	42
SO54784	42
SO54042	42
Other values (27654)	331048

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	2318834
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SO70513
2nd row	SO70517
3rd row	SO70586
4th row	SO70661
5th row	SO70647

Value	Count	Frequency (%)
SO70714	45	< 0.1%
SO58845	43	< 0.1%
SO72656	42	< 0.1%
SO54784	42	< 0.1%
SO54042	42	< 0.1%
SO51555	41	< 0.1%
SO64042	41	< 0.1%
SO61412	40	< 0.1%
SO60233	39	< 0.1%
SO62984	39	< 0.1%
Other values (27649)	330848	99.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
so70714	45	< 0.1%
so58845	43	< 0.1%
so54784	42	< 0.1%
so72656	42	< 0.1%
so54042	42	< 0.1%
so51555	41	< 0.1%
so64042	41	< 0.1%
so61412	40	< 0.1%
so71961	39	< 0.1%
so58572	39	< 0.1%
Other values (27649)	330848	99.9%

Most occurring characters

Value	Count	Frequency (%)
S	331262	14.3%
O	331262	14.3%
6	259047	11.2%
5	241674	10.4%
7	193922	8.4%
4	168104	7.2%
2	137567	5.9%
3	136799	5.9%
1	131361	5.7%
0	130485	5.6%
Other values (2)	257351	11.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1656310	71.4%
Uppercase Letter	662524	28.6%

Most frequent character per category

Value	Count	Frequency (%)
6	259047	15.6%
5	241674	14.6%
7	193922	11.7%
4	168104	10.1%
2	137567	8.3%
3	136799	8.3%
1	131361	7.9%
0	130485	7.9%
8	129506	7.8%
9	127845	7.7%

Value	Count	Frequency (%)
S	331262	50.0%
O	331262	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1656310	71.4%
Latin	662524	28.6%

Most frequent character per script

Value	Count	Frequency (%)
6	259047	15.6%
5	241674	14.6%
7	193922	11.7%
4	168104	10.1%
2	137567	8.3%
3	136799	8.3%
1	131361	7.9%
0	130485	7.9%
8	129506	7.8%
9	127845	7.7%

Value	Count	Frequency (%)
S	331262	50.0%
O	331262	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2318834	100.0%

Most frequent character per block

Value	Count	Frequency (%)
S	331262	14.3%
O	331262	14.3%
6	259047	11.2%
5	241674	10.4%
7	193922	8.4%
4	168104	7.2%
2	137567	5.9%
3	136799	5.9%
1	131361	5.7%
0	130485	5.6%
Other values (2)	257351	11.1%

SalesOrderLineNumber
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.853403047
Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	4
Maximum	8
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9982626371
Coefficient of variation (CV)	0.5386106594
Kurtosis	0.8058291079
Mean	1.853403047
Median Absolute Deviation (MAD)	1
Skewness	1.105900491
Sum	613962
Variance	0.9965282926
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	156023	47.1%
2	98098	29.6%
3	52460	15.8%
4	19846	6.0%
5	4129	1.2%
6	620	0.2%
7	74	< 0.1%
8	12	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	156023	47.1%
2	98098	29.6%
3	52460	15.8%
4	19846	6.0%
5	4129	1.2%
6	620	0.2%
7	74	< 0.1%
8	12	< 0.1%

Value	Count	Frequency (%)
8	12	< 0.1%
7	74	< 0.1%
6	620	0.2%
5	4129	1.2%
4	19846	6.0%
3	52460	15.8%
2	98098	29.6%
1	156023	47.1%

RevisionNumber
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.3 MiB

1	331262

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	331262
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	331262	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	331262	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	331262	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	331262	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	331262	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	331262	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	331262	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	331262	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	331262	100.0%

OrderQuantity
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.3 MiB

1	331262

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	331262
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	331262	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	331262	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	331262	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	331262	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	331262	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	331262	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	331262	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	331262	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	331262	100.0%

UnitPrice
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	133
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	502.3153472
Minimum	12.99
Maximum	2899.99
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	12.99
5-th percentile	67.4
Q1	219
median	369
Q3	699
95-th percentile	1299
Maximum	2899.99
Range	2887
Interquartile range (IQR)	480

Descriptive statistics

Standard deviation	408.9683636
Coefficient of variation (CV)	0.8141665706
Kurtosis	5.756004151
Mean	502.3153472
Median Absolute Deviation (MAD)	230
Skewness	1.894929663
Sum	166397986.5
Variance	167255.1224
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
699	26363	8.0%
758	15501	4.7%
599	15059	4.5%
369	14837	4.5%
869	14503	4.4%
326	12374	3.7%
279	9134	2.8%
299	9133	2.8%
999	9029	2.7%
149.99	8696	2.6%
Other values (123)	196633	59.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12.99	4315	1.3%
14.52	2125	0.6%
21.57	3513	1.1%
25.69	620	0.2%
37.95	582	0.2%
40.55	1458	0.4%
47.95	463	0.1%
49	502	0.2%
56.9	80	< 0.1%
59	649	0.2%

Value	Count	Frequency (%)
2899.99	267	0.1%
2499	2498	0.8%
2295	1708	0.5%
1592.2	5186	1.6%
1299	7935	2.4%
1199	117	< 0.1%
1184.97	195	0.1%
1109	688	0.2%
1099.99	5064	1.5%
1099	376	0.1%

UnitPriceDiscountPct
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.018693662
Minimum	0
Maximum	22.5
Zeros	290427
Zeros (%)	87.7%
Memory size	2.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	18
Maximum	22.5
Range	22.5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.439369563
Coefficient of variation (CV)	2.694499747
Kurtosis	3.832743589
Mean	2.018693662
Median Absolute Deviation (MAD)	0
Skewness	2.381278229
Sum	668716.5
Variance	29.58674124
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	290427	87.7%
18	20910	6.3%
14	14976	4.5%
19.5	2900	0.9%
12.5	1998	0.6%
22.5	51	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	290427	87.7%
12.5	1998	0.6%
14	14976	4.5%
18	20910	6.3%
19.5	2900	0.9%
22.5	51	< 0.1%

Value	Count	Frequency (%)
22.5	51	< 0.1%
19.5	2900	0.9%
18	20910	6.3%
14	14976	4.5%
12.5	1998	0.6%
0	290427	87.7%

ProductStandardCost
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	149
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	208.5625904
Minimum	6.62
Maximum	960.82
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	6.62
5-th percentile	34.36
Q1	91.95
median	169.69
Q3	321.05
95-th percentile	459.4
Maximum	960.82
Range	954.2
Interquartile range (IQR)	229.1

Descriptive statistics

Standard deviation	142.5715625
Coefficient of variation (CV)	0.6835912532
Kurtosis	2.908754623
Mean	208.5625904
Median Absolute Deviation (MAD)	105.77
Skewness	1.226892581
Sum	69088860.82
Variance	20326.65045
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
321.44	26363	8.0%
348.58	15501	4.7%
275.46	15059	4.5%
287.92	14503	4.4%
166.2	12374	3.7%
169.69	12145	3.7%
49.69	8696	2.6%
430.38	7935	2.4%
142.24	7441	2.2%
61.16	7283	2.2%
Other values (139)	203962	61.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.62	4315	1.3%
7.4	2125	0.6%
11	3513	1.1%
13.1	620	0.2%
17.45	582	0.2%
18.65	1458	0.4%
22.05	463	0.1%
22.86	464	0.1%
24.98	502	0.2%
29.01	80	< 0.1%

Value	Count	Frequency (%)
960.82	267	0.1%
827.97	2498	0.8%
760.38	1708	0.5%
527.53	5186	1.6%
505.85	5064	1.5%
459.4	1971	0.6%
444.69	397	0.1%
430.38	7935	2.4%
404.63	136	< 0.1%
397.25	117	< 0.1%

TotalProductCost
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	149
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	208.5625904
Minimum	6.62
Maximum	960.82
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	6.62
5-th percentile	34.36
Q1	91.95
median	169.69
Q3	321.05
95-th percentile	459.4
Maximum	960.82
Range	954.2
Interquartile range (IQR)	229.1

Descriptive statistics

Standard deviation	142.5715625
Coefficient of variation (CV)	0.6835912532
Kurtosis	2.908754623
Mean	208.5625904
Median Absolute Deviation (MAD)	105.77
Skewness	1.226892581
Sum	69088860.82
Variance	20326.65045
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
321.44	26363	8.0%
348.58	15501	4.7%
275.46	15059	4.5%
287.92	14503	4.4%
166.2	12374	3.7%
169.69	12145	3.7%
49.69	8696	2.6%
430.38	7935	2.4%
142.24	7441	2.2%
61.16	7283	2.2%
Other values (139)	203962	61.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.62	4315	1.3%
7.4	2125	0.6%
11	3513	1.1%
13.1	620	0.2%
17.45	582	0.2%
18.65	1458	0.4%
22.05	463	0.1%
22.86	464	0.1%
24.98	502	0.2%
29.01	80	< 0.1%

Value	Count	Frequency (%)
960.82	267	0.1%
827.97	2498	0.8%
760.38	1708	0.5%
527.53	5186	1.6%
505.85	5064	1.5%
459.4	1971	0.6%
444.69	397	0.1%
430.38	7935	2.4%
404.63	136	< 0.1%
397.25	117	< 0.1%

SalesAmount
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	250
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	491.1485504
Minimum	10.6518
Maximum	2899.99
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	10.6518
5-th percentile	67.4
Q1	204.9918
median	369
Q3	699
95-th percentile	1099.99
Maximum	2899.99
Range	2889.3382
Interquartile range (IQR)	494.0082

Descriptive statistics

Standard deviation	402.5377754
Coefficient of variation (CV)	0.8195845738
Kurtosis	5.967969403
Mean	491.1485504
Median Absolute Deviation (MAD)	230
Skewness	1.926724007
Sum	162698851.1
Variance	162036.6606
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
699	23660	7.1%
369	14187	4.3%
599	13573	4.1%
758	13385	4.0%
869	12831	3.9%
326	11368	3.4%
999	8404	2.5%
279	8115	2.4%
299	8061	2.4%
149.99	7482	2.3%
Other values (240)	210196	63.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10.6518	259	0.1%
11.9064	125	< 0.1%
12.99	4056	1.2%
14.52	2000	0.6%
17.6874	377	0.1%
21.0658	93	< 0.1%
21.57	3136	0.9%
25.69	527	0.2%
31.119	81	< 0.1%
33.251	168	0.1%

Value	Count	Frequency (%)
2899.99	198	0.1%
2499	2380	0.7%
2377.9918	69	< 0.1%
2295	1534	0.5%
2049.18	118	< 0.1%
1881.9	174	0.1%
1592.2	4714	1.4%
1305.604	472	0.1%
1299	6002	1.8%
1199	87	< 0.1%

TaxAmt
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	133
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	50.23153472
Minimum	1.299
Maximum	289.999
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1.299
5-th percentile	6.74
Q1	21.9
median	36.9
Q3	69.9
95-th percentile	129.9
Maximum	289.999
Range	288.7
Interquartile range (IQR)	48

Descriptive statistics

Standard deviation	40.89683636
Coefficient of variation (CV)	0.8141665706
Kurtosis	5.756004151
Mean	50.23153472
Median Absolute Deviation (MAD)	23
Skewness	1.894929663
Sum	16639798.65
Variance	1672.551224
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
69.9	26363	8.0%
75.8	15501	4.7%
59.9	15059	4.5%
36.9	14837	4.5%
86.9	14503	4.4%
32.6	12374	3.7%
27.9	9134	2.8%
29.9	9133	2.8%
99.9	9029	2.7%
14.999	8696	2.6%
Other values (123)	196633	59.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.299	4315	1.3%
1.452	2125	0.6%
2.157	3513	1.1%
2.569	620	0.2%
3.795	582	0.2%
4.055	1458	0.4%
4.795	463	0.1%
4.9	502	0.2%
5.69	80	< 0.1%
5.9	649	0.2%

Value	Count	Frequency (%)
289.999	267	0.1%
249.9	2498	0.8%
229.5	1708	0.5%
159.22	5186	1.6%
129.9	7935	2.4%
119.9	117	< 0.1%
118.497	195	0.1%
110.9	688	0.2%
109.999	5064	1.5%
109.9	376	0.1%

Freight
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	133
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	110.5093764
Minimum	2.8578
Maximum	637.9978
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	2.8578
5-th percentile	14.828
Q1	48.18
median	81.18
Q3	153.78
95-th percentile	285.78
Maximum	637.9978
Range	635.14
Interquartile range (IQR)	105.6

Descriptive statistics

Standard deviation	89.97303999
Coefficient of variation (CV)	0.8141665706
Kurtosis	5.756004151
Mean	110.5093764
Median Absolute Deviation (MAD)	50.6
Skewness	1.894929663
Sum	36607557.04
Variance	8095.147924
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
153.78	26363	8.0%
166.76	15501	4.7%
131.78	15059	4.5%
81.18	14837	4.5%
191.18	14503	4.4%
71.72	12374	3.7%
61.38	9134	2.8%
65.78	9133	2.8%
219.78	9029	2.7%
32.9978	8696	2.6%
Other values (123)	196633	59.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.8578	4315	1.3%
3.1944	2125	0.6%
4.7454	3513	1.1%
5.6518	620	0.2%
8.349	582	0.2%
8.921	1458	0.4%
10.549	463	0.1%
10.78	502	0.2%
12.518	80	< 0.1%
12.98	649	0.2%

Value	Count	Frequency (%)
637.9978	267	0.1%
549.78	2498	0.8%
504.9	1708	0.5%
350.284	5186	1.6%
285.78	7935	2.4%
263.78	117	< 0.1%
260.6934	195	0.1%
243.98	688	0.2%
241.9978	5064	1.5%
241.78	376	0.1%

ExtendedAmount
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	133
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	552.5468819
Minimum	14.289
Maximum	3189.989
Zeros	0
Zeros (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	14.289
5-th percentile	74.14
Q1	240.9
median	405.9
Q3	768.9
95-th percentile	1428.9
Maximum	3189.989
Range	3175.7
Interquartile range (IQR)	528

Descriptive statistics

Standard deviation	449.8651999
Coefficient of variation (CV)	0.8141665706
Kurtosis	5.756004151
Mean	552.5468819
Median Absolute Deviation (MAD)	253
Skewness	1.894929663
Sum	183037785.2
Variance	202378.6981
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
768.9	26363	8.0%
833.8	15501	4.7%
658.9	15059	4.5%
405.9	14837	4.5%
955.9	14503	4.4%
358.6	12374	3.7%
306.9	9134	2.8%
328.9	9133	2.8%
1098.9	9029	2.7%
164.989	8696	2.6%
Other values (123)	196633	59.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
14.289	4315	1.3%
15.972	2125	0.6%
23.727	3513	1.1%
28.259	620	0.2%
41.745	582	0.2%
44.605	1458	0.4%
52.745	463	0.1%
53.9	502	0.2%
62.59	80	< 0.1%
64.9	649	0.2%

Value	Count	Frequency (%)
3189.989	267	0.1%
2748.9	2498	0.8%
2524.5	1708	0.5%
1751.42	5186	1.6%
1428.9	7935	2.4%
1318.9	117	< 0.1%
1303.467	195	0.1%
1219.9	688	0.2%
1209.989	5064	1.5%
1208.9	376	0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	DateKey	ProductKey	CustomerKey	PromotionKey	CurrencyKey	OrderDate	DueDate	ShipDate	SaleTypeKey	SalesOrderNumber	SalesOrderLineNumber	RevisionNumber	OrderQuantity	UnitPrice	UnitPriceDiscountPct	ProductStandardCost	TotalProductCost	SalesAmount	TaxAmt	Freight	ExtendedAmount
0	20161110	80	21588	1	100	2016-11-10	2016-11-22	2016-11-17	1	SO70513	1	1	1	40.55	0.0	18.65	18.65	40.550	4.055	8.921	44.605
1	20161110	80	24835	1	98	2016-11-10	2016-11-22	2016-11-17	1	SO70517	1	1	1	40.55	0.0	18.65	18.65	40.550	4.055	8.921	44.605
2	20161111	80	21798	1	100	2016-11-11	2016-11-23	2016-11-18	1	SO70586	1	1	1	40.55	0.0	18.65	18.65	40.550	4.055	8.921	44.605
3	20161112	80	21607	1	100	2016-11-12	2016-11-24	2016-11-19	1	SO70661	1	1	1	40.55	0.0	18.65	18.65	40.550	4.055	8.921	44.605
4	20161112	80	26764	1	6	2016-11-12	2016-11-24	2016-11-19	1	SO70647	1	1	1	40.55	0.0	18.65	18.65	40.550	4.055	8.921	44.605
5	20161113	80	21812	1	100	2016-11-13	2016-11-25	2016-11-20	1	SO70739	1	1	1	40.55	0.0	18.65	18.65	40.550	4.055	8.921	44.605
6	20161114	80	17927	1	6	2016-11-14	2016-11-26	2016-11-21	1	SO70801	1	1	1	40.55	18.0	18.65	18.65	33.251	4.055	8.921	44.605
7	20161114	80	20888	1	100	2016-11-14	2016-11-26	2016-11-21	1	SO70817	1	1	1	40.55	0.0	18.65	18.65	40.550	4.055	8.921	44.605
8	20161114	80	21410	1	100	2016-11-14	2016-11-26	2016-11-21	1	SO70815	1	1	1	40.55	0.0	18.65	18.65	40.550	4.055	8.921	44.605
9	20161116	80	27586	1	6	2016-11-16	2016-11-28	2016-11-23	1	SO70919	1	1	1	40.55	0.0	18.65	18.65	40.550	4.055	8.921	44.605

Last rows

	DateKey	ProductKey	CustomerKey	PromotionKey	CurrencyKey	OrderDate	DueDate	ShipDate	SaleTypeKey	SalesOrderNumber	SalesOrderLineNumber	RevisionNumber	OrderQuantity	UnitPrice	ProductStandardCost	TotalProductCost	SalesAmount	TaxAmt	Freight	ExtendedAmount
331252	20151015	191	15862	1	100	2015-10-15	2015-10-27	2015-10-22	1	SO50073	1	1	1	66.0	33.65	33.65	66.0	6.6	14.52	72.6
331253	20151023	191	26919	1	6	2015-10-23	2015-11-04	2015-10-30	1	SO50150	1	1	1	66.0	33.65	33.65	66.0	6.6	14.52	72.6
331254	20151109	191	27370	1	6	2015-11-09	2015-11-21	2015-11-16	1	SO50470	1	1	1	66.0	33.65	33.65	66.0	6.6	14.52	72.6
331255	20151110	191	15893	1	100	2015-11-10	2015-11-22	2015-11-17	1	SO50478	1	1	1	66.0	33.65	33.65	66.0	6.6	14.52	72.6
331256	20151124	191	15941	1	100	2015-11-24	2015-12-06	2015-12-01	1	SO50610	1	1	1	66.0	33.65	33.65	66.0	6.6	14.52	72.6
331257	20151127	191	20945	1	100	2015-11-27	2015-12-09	2015-12-04	1	SO50647	1	1	1	66.0	33.65	33.65	66.0	6.6	14.52	72.6
331258	20151128	191	21669	1	98	2015-11-28	2015-12-10	2015-12-05	1	SO50765	1	1	1	66.0	33.65	33.65	66.0	6.6	14.52	72.6
331259	20151209	191	15976	1	100	2015-12-09	2015-12-21	2015-12-16	1	SO50891	1	1	1	66.0	33.65	33.65	66.0	6.6	14.52	72.6
331260	20151218	191	27472	1	6	2015-12-18	2015-12-30	2015-12-25	1	SO50993	1	1	1	66.0	33.65	33.65	66.0	6.6	14.52	72.6
331261	20151226	191	15992	1	100	2015-12-26	2016-01-07	2016-01-02	1	SO51067	1	1	1	66.0	33.65	33.65	66.0	6.6	14.52	72.6

Most frequent

	DateKey	ProductKey	CustomerKey	PromotionKey	CurrencyKey	SaleTypeKey	SalesOrderNumber	SalesOrderLineNumber	RevisionNumber	OrderQuantity	UnitPrice	ProductStandardCost	TotalProductCost	SalesAmount	TaxAmt	Freight	ExtendedAmount	count
0	20141229	274	15460	1	100	1	SO46677	1	1	1	399.0	183.49	183.49	399.0	39.9	87.78	438.9	2
1	20141229	274	21193	1	6	1	SO46680	1	1	1	399.0	183.49	183.49	399.0	39.9	87.78	438.9	2
2	20141229	276	13062	1	100	1	SO46679	1	1	1	529.0	243.27	243.27	529.0	52.9	116.38	581.9	2
3	20141229	288	18047	1	100	1	SO46676	1	1	1	199.0	101.46	101.46	199.0	19.9	43.78	218.9	2
4	20141229	371	15460	1	100	1	SO46677	1	1	1	599.0	275.46	275.46	599.0	59.9	131.78	658.9	2
5	20141229	371	21193	1	6	1	SO46680	1	1	1	599.0	275.46	275.46	599.0	59.9	131.78	658.9	2
6	20141229	373	13062	1	100	1	SO46679	1	1	1	326.0	166.20	166.20	326.0	32.6	71.72	358.6	2
7	20141229	385	18047	1	100	1	SO46676	1	1	1	326.0	166.20	166.20	326.0	32.6	71.72	358.6	2
8	20141230	280	12947	1	100	1	SO46685	1	1	1	329.0	167.73	167.73	329.0	32.9	72.38	361.9	2
9	20141230	284	18125	1	100	1	SO46684	1	1	1	489.0	224.87	224.87	489.0	48.9	107.58	537.9	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent